import pandas as pd
id=['0','1','2','3']
dict={'姓名':['赵文','李萌','刘武','荷花'],'职务':['主管','副主管','员工','员工'],'基本工资':[8000,7000,5000,5500],'联系方式':[120,110,119,443]}
c=pd.DataFrame(dict,id)
print(c)
c.loc[4]=['李华','员工',5200,136]
print(c)
c.insert(1,'性别',['女','男','男','女','女'],allow_duplicates=True)
print(c)
c1=c.rename({'员工':'副主管'},axis='columns')
c1['职务']=['主管','副主管','副主管','员工','员工']
print(c1)
print(c1[(c1['职务']=='主管') | (c1['职务']=='副主管')])
c.to_csv('Score.csv',encoding='GBK')
c2=pd.read_csv('Score.csv',index_col=0,encoding='GBK')
print(c2)